﻿if exists (select 1
            from  sysobjects
           where  id = object_id('GXBZ_EMR_SCBCJL')
            and   type = 'U')
   drop table GXBZ_EMR_SCBCJL
go

/*==============================================================*/
/* Table: GXBZ_EMR_SCBCJL                                       */
/*==============================================================*/
create table GXBZ_EMR_SCBCJL (
   ZYJZLSH              varchar(64)          not null,
   XGBZ                 varchar(1)           not null,
   GRJBXXBSH            varchar(64)          not null,
   CXJMJKDABH           varchar(17)          not null,
   CJSJ                 datetime             null,
   WDCJZGH              varchar(64)          null,
   WDCJZXM              varchar(30)          null,
   WDGLJGDM             varchar(22)          null,
   WDGLJGMC             varchar(22)          null,
   JLRQSJ               datetime             null,
   SJYSGH               varchar(64)          null,
   SJYSXM               varchar(30)          null,
   ZYYSGH               varchar(64)          null,
   ZYYSXM               varchar(30)          null,
   BCH                  varchar(10)          null,
   BCHMC                varchar(50)          null,
   BFH                  varchar(10)          null,
   BFHMC                varchar(50)          null,
   KSBM                 varchar(20)          null,
   KSMC                 varchar(100)         null,
   BQBM                 varchar(20)          null,
   BQMC                 varchar(100)         null,
   YLJGDM               varchar(22)          null,
   YLJGMC               varchar(70)          null,
   ZS                   varchar(1024)        null,
   BLTDMS               varchar(2000)        null,
   ZYSZGCJG             varchar(1024)        null,
   ZDYJ                 varchar(100)         null,
   XYCZDM               varchar(64)          null,
   XYCZMC               varchar(512)         null,
   ZYCZDM               varchar(64)          null,
   ZYCZMC               varchar(512)         null,
   ZYCZZHDM             varchar(64)          null,
   ZYCZZHMC             varchar(512)         null,
   XYJZMC               varchar(512)         null,
   ZYJZMC               varchar(512)         null,
   ZYJZZHMC             varchar(512)         null,
   ZLJH                 varchar(2000)        null,
   ZZZF                 varchar(100)         null,
   MJ                   varchar(16)          not null,
   TBRQ                 datetime             not null,
   SCZT                 varchar(1)           not null,
   CS_JYBZ              int                  not null,
   SCSJ                 datetime             not null,
   constraint PK_GXBZ_EMR_SCBCJL primary key (ZYJZLSH, XGBZ)
)
go
